I have 50 tables in a database. I want to fine
unique key of all the tables. Is there query to know this or I have to check
one by one by opening table structure.
If is it possible then please help me…
Thanks..
How to find unique key in Sql Server?
2282
16-Sep-2017
Updated on 16-Sep-2017
Sushant Mishra
16-Sep-2017There are many method I am telling you using system stored procedure
At a time you can find unique key of single table for every table you have to run different stored procedure
Here students is the table name
when you execute this procedure it will give output